Last updated on SEPTEMBER 21, 2023

DBMS_OUTPUT.PUT_LINE() does not produce the expected output, it gets truncated, when using ARRAYSIZE.

Example (The below example should have 1188  lines of DBMS_OUTPUT.PUT_LINE(1);)

SET ARRAY 1000;

SET SERVEROUT ON;

SPO "test-plus-&_SQLPLUS_RELEASE.-on-rdbms-&_O_RELEASE..txt"

BEGIN

DBMS_OUTPUT.PUT_LINE(1);

DBMS_OUTPUT.PUT_LINE(1);

DBMS_OUTPUT.PUT_LINE(1);

DBMS_OUTPUT.PUT_LINE(1);

DBMS_OUTPUT.PUT_LINE(1);

DBMS_OUTPUT.PUT_LINE(1);

.

.

DBMS_OUTPUT.PUT_LINE(1);

END;

/

SPO off

The spool file created only shows 1000 lines.

The same script works fine in 12.1.0.2 and 11.2.0.4 and shows 1188 lines.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.